dxp-ux
8gh-0o9/GET all Payments (TMF-676)
listPayment
This operation retrieves the payment history by using account number.
This operation is towards
- LCPR: Aria, Matrixx, CSG.
- Panama: Liberate
- LC markets (JM,VC,LC,GD,AG,BB,TC,KY,AI,KN,MS,VG,TT,CW,DM): Liberate, Cerillion, Amdocs
Request URL
https://[localhost]:[port]/dxp-ux/v1/{businessId}/paymentURL PARAMS
| name | type | description | required |
|---|---|---|---|
| businessId | string | 2 letter ISO 3166 country code (TT, BB, JM, PA, etc.) identifying the business unit. | Y |
Header
| name | value | description | required (mandatory-Y, optional-N, Not applicable- N/A) |
|---|---|---|---|
| client_id | string | The client_id identifying the channel. Minimum characters: 5 | Y(PR, PA,LC) |
| client_secret | string | Password associated with the client_id. Minimum characters: 5 | Y(PR, PA,LC) |
| X-Correlation-ID | string | Identifier that correlates HTTP request between a client and server. Any identification model (UUDI, checksum, etc.) can be used, as long as it is a unique value to differentiate a transaction. | Y(PR, PA,LC) |
| channelId | string | Channel to business Allowed Value : APP | Y(PR) N/A(PA, LC) |
| lob | string | The Line of Business Identifier Allowed ENUM values: FIXED, PREPAID, POSTPAID | Y (PR. For Matrixx not in scope) N/A(PA, LC) |
| targetSystem | string | Expected target system: csg, matrixx, aria | Y (PR) N/A(PA, LC) |
Query Param
| name | type | description | required (mandatory-Y, optional-N, Not applicable- N/A) |
|---|---|---|---|
| account_no | string | To retrieve the payments from a specific account | Y(PR, PA, LC) |
| startDate | DateTime | To retrieve the payments performed after this date | N(PR, PA, LC) |
| endDate | DateTime | To retrieve the payments performed before this date | N(PR, PA, LC) |
| paymentItem.referredType | string | To retrieve the payments from a specific referredType Possible values are: history, planDetails, plansByAcct, receipt, deposits, depositDetails, items, summary | N/A (PR, CWC - Cerillion, Amdocs) N(PA, LC- Liberate) |
Data Model
Response Data Model
| name | type | description | required (mandatory-Y, optional-N, Not applicable- N/A) |
|---|---|---|---|
| id | string | Unique identifier of Payment | Y(PR, PA , LC) |
| description | string | Text describing the contents of the payment | N(PR) Y(PA), N/A(LC) |
| correlatorId | string | Unique identifier in the client for the payment in case it is needed to correlate | N(PR) Y(PA) N(LC) |
| status | string | Status of the payment | N(PR) Y(PA, LC- Liberate, Cerillion), N/A (LC-Amdocs) |
| statusDate | datetime or string | Date when the status was recorded Note for PA: This field type is string | N(PR) Y(PA,LC) |
| name | string | Screen name of the payment | N(PR, LC- Liberate) Y(PA), N/A (LC- Cerillion, Amdocs) |
| paymentDate | datetime or string | Date when the payment was performed Note for PA: This field type is string | N(PR) Y(PA, LC) |
| channel | object | The channel to which the resource reference | N (LC- Liberate, Cerillion ), N/A (LC- Amdocs) |
| channel.id | string | Unique identifier of the channel | N (LC- Liberate, Cerillion ), N/A (LC- Amdocs) |
| channel.'@referredType' | string | The actual type of the target instance when needed for disambiguation | N (LC- Liberate, Cerillion ), N/A (LC- Amdocs) |
| extendedCharacteristics[] | array | Represents additional attributes of payment entity | N(PR) N/A(PA,LC) |
| extendedCharacteristics[].name | string | name of the additional attributes (ex: "paymentDate", "procStatusCode") | N(PR) N/A(PA,LC) |
| extendedCharacteristics[].value | string | value of the additional attributes(ex: "2023-06-09", 100) | N(PR) N/A(PA, LC) |
| account | object | Account reference. A account may be a party account or a financial account. | N(PR) Y(PA, LC) |
| account.id | string | Unique identifier of the account | N(PR) Y(PA, LC) |
| account.@type | string | When sub-classing, this defines the sub-class entity name | N(PR,LC) N/A(PA) |
| account.name | string | Name of the account | Y(PA), N(PR, LC- Liberate, Amocs), N/A (LC- Cerillion) |
| account.description | string | Detailed description of the account | N/A(PR) Y(PA), N/A(LC) |
| amount | object | A base / value business entity used to represent money | N(PR,LC) N/A(PA) |
| amount.value | number | A positive floating point number | N(PR,LC) N/A(PA) |
| amount.unit | string | Currency (ISO4217 norm uses 3 letters to define the currency) | N(PR) N/A(PA, LC) |
| amount.amount | number | A positive floating point number | N(PR) N/A(PA, LC) |
| paymentMethod | object | link to the resource that holds information about the payment mean used to complete the operation | Y(PR, PA, LC) |
| paymentMethod.id | string | Unique Identifier within the server for the payment method. | N(PR) N/A(PA, LC) |
| paymentMethod.@type | string | When sub-classing, this defines the sub-class entity name | N(PR) Y(PA, LC) |
| paymentMethod.details | object | Details of payment method | N(PR) N/A(PA,LC) |
| paymentMethod.details.type | string | Type of payment method | N(PR) N/A(PA,LC) |
| paymentMethod.details.cardNumber | string | Card Number | N(PR) N/A(PA, LC) |
| paymentMethod.details.expirationDate | string | Card Expiry Date | N(PR) N/A(PA, LC) |
| paymentItem[] | array | The paymentItem is the result of lettering process. It enables to assign automatically or manually part of incoming payment amount to a bill | N(PR) Y(PA,LC) |
| paymentItem[].totalAmount | object | A base / value business entity used to represent money | N(PR) Y(PA,LC) |
| paymentItem[].totalAmount.amount | number | A positive floating point number | N(PR) N/A(PA, LC) |
| paymentItem[].totalAmount.value | number | A positive floating point number | N/A(PR) Y(PA, LC) |
| paymentItem[].item | object | Entity reference schema to be use for all entityRef class. | N(PR) Y(PA, LC) |
| paymentItem[].item.id | string | Unique identifier of a related entity. | N(PR) N/A(PA, LC- Amdocs), Y(LC- Liberate, Ceriilion) |
| paymentItem[].item.referredType | string | The actual type of the target instance when needed for disambiguation. | N(PR) N/A(PA, LC) |
| paymentItem[].item.@referredType | string | The actual type of the target instance when needed for disambiguation. | N/A(PR) Y(PA, LC) |
| item | object | Reference where to get more information about the entity with another API call | N(PR) N/A(PA, LC- Liberate, Amdocs), Y(CWC- Cerillion) |
| item.referredType | string | The actual type of the target instance when needed for disambiguation. | N(PR) N/A(PA, LC) |
| item.'@referredType' | string | The actual type of the target instance when needed for disambiguation. | N(PR) N/A(PA, LC- Liberate, Amdocs), Y(LC- Cerillion) |
| item.id | string | Unique identifier of a related entity. | N(PR) N/A(PA, LC- Liberate, Amdocs), Y(CWC- Cerillion) |
| refund[] | array | array for the refund details | N(PR) N/A(PA, LC) |
| refund[].id | string | Refunded id (unique) from matrixx | N(PR) N/A(PA, LC) |
| refund[].totalAmount | object | refund amount details | N(PR) N/A(PA, LC) |
| refund[].totalAmount.value | number | refund amount value | N(PR) N/A(PA, LC) |
| refund[].totalAmount.unit | string | Currency (ISO4217 norm uses 3 letters to define the currency) | N(PR) N/A(PA,LC) |
| refund[].status | string | staus of the refund(ex: refunded) | N(PR) N/A(PA, LC) |
| refund[].refundDate | datetime | Date of the refund | N(PR) N/A(PA, LC) |
| refund[].@type | string | When sub-classing, this defines the sub-class entity name(ex: "RefundRef") | N(PR) N/A(PA, LC) |
| totalAmount | object | A base / value business entity used to represent money | N(PR) Y(PA, LC) |
| totalAmount.value | number | A positive floating point number | N(PR) Y(PA, LC) |
| totalAmount.unit | string | Currency (ISO4217 norm uses 3 letters to define the currency) | N(PR, LC) N/A(PA) |
| totalAmount.amount | number | A positive floating point number | N(PR) N/A(PA, LC) |
| taxAmount | object | A base / value business entity used to represent money | N(PR,LC- Cerillion, Amdocs) N/A(PA, LC-Liberate) |
| taxAmount.amount | number | A positive floating point number | N(PR, LC - Cerillion) N/A(PA) |
| taxAmount.value | number | Value of the tax amount | N/A(PR, PA, LC-Liberate), N(LC- Cerillion, Amdocs) |
| @type | string | When sub-classing, this defines the sub-class entity name | N(PR) N/A(PA, LC) |
paymentItem subResource - dataModel
| @referredType | type | description | required(mandatory-Y, optional-N, Not applicable- N/A) | examples |
|---|---|---|---|---|
| payment | string | The actual type of the target instance when needed for disambiguation. | Y(PA), N(CWC) | PA: { "item": { "@referredType": "payment"}} LC: { "totalAmount": { "amount": 3650 }, "item": { "referredType": "payment" } } |
| deposit | string | The actual type of the target instance when needed for disambiguation. | Y(PA), N(CWC) | PA: {"item": { "@referredType": "deposit"}} LC: { "totalAmount": { "amount": 0 }, "item": { "referredType": "deposit" } } |
extendedCharacteristics subResource - dataModel
| resource characteristic name | type | description | required(mandatory-Y, optional-N, Not applicable- N/A) | examples |
|---|---|---|---|---|
| procStatusCode | string | Response code from payment processor (Braintree). Possible Values will be :1000(Approved), 4001(settlement_declined), 4000(settled), 81706(CVV is required), ARIA COMM 1 (voided payment), etc... | N(PR) N/A(PA, LC) | PR: { "name": "procStatusCode", "value": "1000" } |
| paymentDate | string | Processor payment date | N(PR) N/A(PA, LC) | PR: { "name": "paymentDate", "value": "2024-02-13" } |
| procPaymentId | string | The processor payment ID | N(PR) N/A(PA, LC) | PR: { "name": "procPaymentId", "value": "bkh04029" } |
| paymentMethodNo | string | Processor payment method number | N(PR) N/A(PA, LC) | PR: { "name": "paymentMethodNo", "value": "1" } |
| procStatusText | string | Payment processor status text is returned The possible payment status is either 'Approved or settled or Settlement Pending or External Payment or Cash Credit or Insufficient Funds or fail or {Unknown} | N(PR) N/A(PA, LC) | PR: { "name": "procStatusText", "value": "Approved" } |
Key considerations
- Please find the responses in following URL: DXP UX : PaymentHistory
PA Implementation
1. This implementation retrieves the payment history for FIXED, POSTPAID accounts.
2. To retrieve payment history for a specific duration, startDate and endDate queryParameters must be passed.
3. If the dates are not specified in queryParams, the API returns history of last one year by default.
4. Description field provides the billReferenceNumber.
5. statusDate field is the enteredDate in Liberate.
6. name field gives the name value which is sent during creating the payment (ThirdPartySource).
7. correlatorId field gives the correlatorId value which is sent during creating the payment (ThirdPartyPaymNo).
8. status possible values are "Returned" or "Success".
9. By default, payment history is retrieved if 'paymentItem.referredType' queryParam is not provided; if specified, it must be sent as "history"
10. For all the dateTime fields
- Any datetime before 1908-04-22 will show offset -05:18
- Any datetime on or after 1908-04-22 will show offset -05:00LC Implementation
1. This implementation retrieves the payment history for FIXED, POSTPAID accounts.
2. To retrieve payment history for a specific duration, startDate and endDate queryParameters must be passed.
3. If the dates are not specified in queryParams, the API returns history of last one year by default.
4. "name" field gives the name value which is sent during creating the payment (ThirdPartySource).
5. correlatorId field gives the correlatorId value which is sent during creating the payment (ThirdPartyPaymNo).
6. "status" possible values are "Returned" or "Success" or "Processing" (If there any pending transactions in Redmond).
7. "id" field refers to the payment number.
8. paymentItem[].item.id refers to the bill reference number.
9. By default for liberate, payment history is retrieved if 'paymentItem.referredType' queryParam is not provided; if specified, it must be sent as "history"
10. For all the dateTime fields for JM,
- Any datetime before 1912-02-01 will show offset -05:07
- Any datetime on or after 1912-02-01 will show offset -05:00Possible values for payment methods for liberate:
| Payment Method | Description |
|---|---|
| ( | Online Payments |
| * | IVR Credit Card |
| _ | Eservice Credit Card |
| 0 | ** COMVERSE PAYMENT |
| < | ECOMMERCE VISA CARD |
| > | Portal Credit Card |
| @ | Recurrng Credit Card |
| A | CANADIAN |
| C | CASH |
| D | DIRECT DEBIT |
| E | CREDIT CARD |
| F | DEBIT CARD |
| G | CUSTOMER DISCOUNT |
| H | DEALOR PAYMENTS |
| I | Ecommerce VISA Card |
| K | IVR Credit Card |
| L | M-Wallet |
| M | MANAGER'S CHEQUE |
| N | C&W Online |
| O | OTHER / SUNDRY |
| P | CANADIAN |
| Q | CHEQUE |
| R | REDEEM REWARD POINTS |
| S | salary deduction |
| T | GCT Withholding TaxC |
| U | U.S. DOLLARS |
| V | British Pound |
| W | Wire Transfer Paymen |
| X | Staff Bill Payment |
| Y | CAYMAN DOLLARS |
| | | Mobile BillPay App |
| } | Ecommerce MasterCard |
Get Payment Plans
This API allows consumer to returns the list of payment plans on the account.
URL
https://[localhost]:[port]/dev/dxp-ux/dxp-ux/v1/{businessId}/paymenturl Param
| name | type | description | required |
|---|---|---|---|
| businessId | string | 2 letter ISO 3166 country code (TT, BB, JM, PA, etc.) identifying the business unit. | Y |
Header
| name | value | description | required |
|---|---|---|---|
| client_id | string | The client_id identifying the channel. | Y |
| client_secret | string | Password associated with the client_id. | Y |
| X-Correlation-ID | string | Identifier that correlates HTTP request between a client and server. Any identification model (UUDI, checksum, etc.) can be used, as long as it is a unique value to differentiate a transaction. | Y |
Query Param
| name | type | description | required |
|---|---|---|---|
| account.id | string | BAN-CAN ( client_acct_id ) | Y |
cURL request
curl --location 'https://nonprod.esb.cloud.lla.com/dev/dxp-ux/dxp-ux/v1/PR/payment?account.id=DAVE2025062416' \
--header 'X-Correlation-ID: 644e1dd7-2a7f-18fb-b8ed-ed78c3F92c2b' \
--header 'client_id: 784c9a6dd7ae49768816cab57fcf1fa1' \
--header 'client_secret: 187b259EB77441babbF611d2646C670d'Definitions
Each of the request parameters is detailed.
| name | type | description | required |
|---|---|---|---|
| id | string | Aria-assigned payment plan no. | N |
| status | string | Specifies the other status of payment plan (active, completed, or cancelled). | N |
| paymentItem | array | N | |
| paymentItem.item | object | N | |
| paymentItem.item.id | string | Client-defined unique payment plan ID. | N |
| paymentItem.item.name | string | Payment plan name. | N |
| paymentItem.amount | object | Specifies the balance to be paid by the payment plan at time of payment plan creation. Specifies the remaining balance to be paid by the payment plan at the time of the API call. The paid amount of payment plan at the time of the API call. | N |
| paymentItem.amount.value | number | Contains the balance of either 'InitialBalance', 'RecurringAmount', or 'PaidAmount | N |
| paymentItem.amount.unit | string | Currency (ISO4217 norm uses 3 letters to define the currency) | N |
| paymentItem.@referredType | string | Balance differentiator | N |
| paymentMethod | object | Holds information about the payment plan accounts | N |
| paymentMethod.account | array | list of payment plan accounts | N |
| paymentMethod.account.id | string | unique account id Please refer below 'paymentMethod account values' table for more details | N |
| paymentMethod.account.name | string | name of the account | N |
| extendedCharacteristic | array | Describes the characteristic of a payment plan | N |
| extendedCharacteristic.name | string | Name of the characteristic | N |
| extendedCharacteristic.value | any | Value of the of the characteristic | N |
| extendedCharacteristic.valueType | string | Data type of the characteristic | N |
| @type | string | This defines the sub-class entity name, in this case 'PaymentPlan' | N |
paymentMethod account values
| paymentMethod account name | type | description | required |
|---|---|---|---|
| ClientBillingGroupId | string | Client-defined billing group ID. | N |
| AlignedPaymentPlanClientMasterPlanInstanceId | string | The client-defined unique identifier for master plan instance that will be used to communicate upcoming payment due. Mandatory when payment_plan_type = 0. | N |
extendedCharacteristic values
| extendedCharacteristic name | type | description | required |
|---|---|---|---|
| PaymentPlanDescription | string | Payment plan description. | N |
| PaymentPlanCreateDate | string | Date when payment plan created. | N |
| FirstPaymentPlanDueDate | string | The date of the first payment plan will be due. | N |
| LastPaymentPlanDueDate | string | The date of the last payment plan will be due. | N |
| PaymentPlanType | number | Specifies the payment plan type for the account. Allowable values are: 0 - Aligned with an existing master plan instance anniversary statement or 1 - Independent, its own payment plan schedule and due dates. | N |
| PaymentPlanLength | number | Specifies the length of payment plan. For payment_plan_type = 1, the input will be used jointly with payment_plan_interval. For payment_plan_type = 0, it is the number of MPI statements that the payment plan will be part of. | N |
| TransactionOnPaymentPlanList | array | A list of transactions on a payment plan. Please refer below 'transaction_on_payment_plan_list array values' table for more details | N |
transaction_on_payment_plan_list array values
| extendedCharacteristic name | type | description | required |
|---|---|---|---|
| transactionCreateDate | string | The creation datetime of this transaction. | N |
| transactionId | number | Unique transaction ID. | N |
| invoiceNo | number | The Aria-assigned unique identifier for invoices. | N |